package com.crm.dao.before_sale;

import com.crm.pojo.ClientNeed;
import com.crm.vo.ClientNeedVO;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;


import java.util.List;

public interface NeedDAO extends CrudRepository<ClientNeed,Long> , JpaSpecificationExecutor<ClientNeed> {


    //逻辑删除需求
    @Query(nativeQuery = true,value = "update CLIENT_NEED set CLIENT_NEED_IS_DEL='是' where NEED_ID=?1")
    @Modifying
    public void deleteClientNeedById(Long needId);
}
